package com.fg.pro.sys.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fg.pro.model.sys.entity.SysMenu;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 菜单权限(SysMenu)表数据库访问层
 *
 * @author makejava
 * @since 2025-07-17 10:10:47
 */
@Mapper
public interface SysMenuDao extends BaseMapper<SysMenu> {

    @Select("select * from sys_menu where id in ( select menu_id from sys_role_menu where role_id = #{roleId})")
    List<SysMenu> getMenuByRoleId(Long roleId);
}

